package com.ruoyi.teaching.mapper;

import java.util.List;
import com.ruoyi.teaching.domain.TeachingSchool;
import com.ruoyi.teaching.domain.vo.TeachingSchoolStatisticVO;

/**
 * 教务校区Mapper接口
 * 
 * @author William
 * @date 2022-10-10
 */
public interface TeachingSchoolMapper 
{
    /**
     * 查询教务校区
     * 
     * @param schoolId 教务校区主键
     * @return 教务校区
     */
    public TeachingSchool selectTeachingSchoolBySchoolId(Long schoolId);

    /**
     * 查询教务校区
     *
     * @param areaCode 区域ID
     * @return 教务校区
     */
    public List<TeachingSchool> selectTeachingSchoolByAreaCode(Long areaCode);

    /**
     * 查询所有学校
     */
    public List<TeachingSchool> selectTeachingSchoolAll();

    /**
     * 查询教务校区列表
     * 
     * @param teachingSchool 教务校区
     * @return 教务校区集合
     */
    public List<TeachingSchool> selectTeachingSchoolList(TeachingSchool teachingSchool);

    /**
     * 新增教务校区
     * 
     * @param teachingSchool 教务校区
     * @return 结果
     */
    public int insertTeachingSchool(TeachingSchool teachingSchool);

    /**
     * 修改教务校区
     * 
     * @param teachingSchool 教务校区
     * @return 结果
     */
    public int updateTeachingSchool(TeachingSchool teachingSchool);

    /**
     * 删除教务校区
     * 
     * @param schoolId 教务校区主键
     * @return 结果
     */
    public int deleteTeachingSchoolBySchoolId(Long schoolId);

    /**
     * 批量删除教务校区
     * 
     * @param schoolIds 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteTeachingSchoolBySchoolIds(String[] schoolIds);

    /**
     * 根据学校ID 统计数据
     * @param schoolId
     * @return
     */
    public TeachingSchoolStatisticVO selectSchoolStatisticVoBySchoolId(Long schoolId);
}
